| Column | Data Type | Nullable | Default | Description |
| SalesPersonID | int | not null | | Primary key for SalesTerritoryHistory records. |
| TerritoryID | int | not null | | Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID. |
| StartDate | datetime | not null | | Date the sales representive started work in the territory. |
| EndDate | datetime | null | | Date the sales representative left work in the territory. |
| rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |